﻿<!DOCTYPE html>
<html>
<head>
   <title>Dynamic and Manual Entry Queries</title>
   <meta http-equiv="X-UA-Compatible" content="IE=edge" />
   <meta name="generator" content="Help &amp; Manual" />
   <meta name="keywords" content="" />
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
   <meta http-equiv="content-language" content="en-us" />
   <meta name="description" content="An SQL query is the abbreviation for Structured Query Language, and is pronounced either see-kwell or as separate letters. SQL is a standardized query language for requesting..." />
   <meta http-equiv="Content-Style-Type" content="text/css" />
   <link type="text/css" href="default.css" rel="stylesheet" />
   <link id="tabscheme" type="text/css" href="hm_topic.css" rel="stylesheet" />   
<style type="text/css">
/* No header topics */

/* Breadcrumb trail */
p#breadcrumbs {
font-family: Verdana, Tahoma, Helvetica, Sans-Serif;   padding: 2px 0 1px 2px;
   margin: 0;
   font-size: 8pt; 
   color: #999;
   }   
p#breadcrumbs a { color: #999; text-decoration: none;}
p#breadcrumbs a:visited { color: #999; }
p#breadcrumbs a:hover { color: #333; border-bottom: 1px dotted #333; }

/* Search hightlight color */
span.highlight {background-color: #ffff40;}
</style>
<script type="text/javascript">
var hmHeaderTopic = true;

</script> 
<!--[if IE 9]>
<link id="iesvgcss" rel="stylesheet" type="text/css" href="hm_webhelp_svg.css" />
<![endif]-->	
<script src="jquery.js"></script>
<script type="text/javascript" src="jquery.tools.min.js"></script>
<script type="text/javascript" src="jquery.scrollTo-min.js"></script>
<script type="text/javascript"> 
// General topic variables
var tVars = {
   hmHelpPage: "index.html",
   nextP: "custom_report_functions.htm",
   prevP: "filtering_patient_location_and_treatment_loc.htm",
   currP: "dynamic_and_manual_entry_queries.htm",
   defP: "iqcare_module.htm",
   titleP: "Dynamic and Manual Entry Queries",
   mailsubject: "Feedback on: IQCare SCM User Guide V3.5a - Dynamic and Manual Entry Queries",
   simplesubject: "Documentation%20Feedback",
   mailid: "Dynamic_and_Manual_Entry_Queries",
   mailpath: "IQCare Clinical Interface, Configuration, Form Builder &gt; Custom Reports &gt; Dynamic and Manual Entry Queries /",
   mailbody: "Dear Support Staff,",
   mailrecipient: "Support Staff <support@ec-software.com>",
   simplerecipient: "support@ec-software.com",
   fbtype: false,
   header: true,
   background: "bg.png",
   tablesReady: false,
   togglesReady: false,
   webRedirect: true
   }
// Popup configuration
 var hmpBShadow = true;
 var hmPopSmallDim = 500;
 var hmPopKillVideo = false;
 // AutoTOC variables
 var hmatocvars = {
   atoc_show: true,
   atoc_title: "Contents",
   atoc_tip: "Jump to:&nbsp;",
   atoc_minHeaders: 3,
   atoc_btntip_off: "No contents entries on this page",
   atoc_btntip_on: "Display/hide topic directory",
   atoc_toptip: "Jump to top of page",
   atoc_top: "Scroll to Top of Page",
   atoc_bg: "#f6f6f6",
   atoc_border: "silver",
   atoc_linkcolor: "#444",
   atoc_linklimit: 45,
   atoc_hovercolor: "#000",
   atoc_hoverbgcolor: "#e0e0e0"
}
// Sortable tables
var sortVars = {
   europeandate: false,
   germanNumbers: false,
   imagePath: "",
   image_up: "arrow-up.gif",
   image_down: "arrow-down.gif",
   image_empty: "arrow-empty.gif",
   image_none: "arrow-none.gif",
   sort_tip: "Click to sort on this column",
   umlauts: "false"
   }

</script>

<script type="text/javascript"> 
$(document).ready(function() {
var doc = document;  
try {
if (parent.hmWebHelp.navWidth != null) doc = parent.document;
doc.title = $("<div/>").html("IQCare SCM User Guide V3.5a - Dynamic and Manual Entry Queries").text();
window.onunload = function() {doc.title = $("<div/>").html("IQCare SCM User Guide V3.5a").text();}
} catch(err) {}
});
</script>
<script type="text/javascript" src="helpman_settings.js"></script>
<script type="text/javascript" src="helpman_topicinit.js"></script>
<script type="text/javascript" src="hmtopic.js"></script>

   <script type="text/javascript">
     HMSyncTOC("index.html", "dynamic_and_manual_entry_queries.htm");
   </script>
   <script type="text/javascript" src="highlight.js"></script>
   <script type="text/javascript">
     $(document).ready(function(){highlight();});
   </script>
</head>
<body>
<!--ZOOMSTOP-->
<ul id="topictabs" class="tabs">
<li id="indextab" class="hmtabs"><a href="#" id="indextablink" class="current"><span>Dynamic and Manual Entry Queries</span></a></li>
</ul>
<div id="hmbox">
<div id="hmheader">
<div id="hmheadercontents">
 
<h1 class="p_Heading1"><span class="f_Heading1">Dynamic and Manual Entry Queries</span></h1>

</div>
<div id="atocIcon" class="navdivs">
<img class="navicon" id="hmAtocLink" src="contents_off.png" alt="No contents entries on this page" title="No contents entries on this page" />
<br /><span>Contents</span>
</div>
</div>
<div id="autoTocWrapper" class="topicmenu"></div>
<div id="idcontent">
<div id="unclicker"></div>

<!--ZOOMRESTART-->
<p>An SQL query is the abbreviation for <span style="font-weight: bold;">S</span><span style="font-style: italic;">tructured </span><span style="font-style: italic; font-weight: bold;">Q</span><span style="font-style: italic;">uery </span><span style="font-style: italic; font-weight: bold;">L</span><span style="font-style: italic;">anguage</span>, and is pronounced either see-kwell or as separate letters. SQL is a standardized query language for requesting information from a database. IQCare uses SQL to request data from the database in order to create Custom Reports. The Custom Reports feature of IQCare provides a tool for you to create SQL dynamically or “on the fly”. By selecting the field groupings and fields along with the filters and functions, you direct IQCare to generate a complex SQL statement that pulls the correct data in the requested format into a report. This SQL can be seen at the bottom of the Custom Reports configuration page. Note that as you add fields and functions, the SQL builds and the statement gets larger. </p>
<p>&nbsp;</p>
<p><img id="TOGGLE0186A1_ICON" src="hmtoggle_arrow1.gif" width="9" height="9" alt="AR Forms" title="AR Forms" style="border:none" /> &nbsp; &nbsp; &nbsp; &nbsp;<a class="dropdown-toggle" title="AR Forms" href="javascript:HMToggle('toggle','TOGGLE0186A1','TOGGLE0186A1_ICON')">Dynamic Query Mode</a> </p>
<div id="TOGGLE0186A1" style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 10px;"><table style="border:none; border-spacing:0px; border-collapse:collapse;">
<tr style="text-align:left;vertical-align:top;">
<td style="vertical-align:top; padding:2px; border:solid 1px #000000;"><p>In Dynamic Query mode the dynamic report configuration is enabled and the advanced query option where you can type SQL is disabled. </p>
<p>&nbsp;</p>
<p><img src="customreportdynamicquery.png" width="673" height="435" alt="CustomReportDynamicQuery" style="border:none" /></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>
<p><img id="TOGGLE0186A2_ICON" src="hmtoggle_arrow1.gif" width="9" height="9" alt="AR Forms" title="AR Forms" style="border:none" /> &nbsp; &nbsp; &nbsp; &nbsp;<a class="dropdown-toggle" title="AR Forms" href="javascript:HMToggle('toggle','TOGGLE0186A2','TOGGLE0186A2_ICON')">Type SQL Mode</a></p>
<div id="TOGGLE0186A2" style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 10px;"><table style="border:none; border-spacing:0px; border-collapse:collapse;">
<tr style="text-align:left;vertical-align:top;">
<td style="vertical-align:top; padding:2px; border:solid 1px #000000;"><p>Sometimes, the reports you want to create can not be generated using the dynamic SQL feature in IQCare. In that case, you can use the Type SQL option and simply type or cut and paste the SQL statement you want run,into the box provided at the end of the Custom Report configuration page. In Type SQL mode the dynamic report configuration is disabled and the advanced query option where you can type SQL is enabled.</p>
<p>&nbsp;</p>
<p><img src="customreporttypesql.png" width="673" height="430" alt="CustomReportTypeSQL" style="border:none" /></p>
<p>&nbsp;</p>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>

<!--ZOOMSTOP--> 


</div> <!-- idcontent -->
</div><!-- hmbox --> 
<script type="text/javascript">
HMInitToggle('TOGGLE0186A1_ICON','hm.type','dropdown','hm.state','0','hm.src0','hmtoggle_arrow0.gif','hm.src1','hmtoggle_arrow1.gif','onclick','HMToggle(\'toggle\',\'TOGGLE0186A1\',\'TOGGLE0186A1_ICON\')');
HMInitToggle('TOGGLE0186A1','hm.type','dropdown','hm.state','0');
HMInitToggle('TOGGLE0186A2_ICON','hm.type','dropdown','hm.state','0','hm.src0','hmtoggle_arrow0.gif','hm.src1','hmtoggle_arrow1.gif','onclick','HMToggle(\'toggle\',\'TOGGLE0186A2\',\'TOGGLE0186A2_ICON\')');
HMInitToggle('TOGGLE0186A2','hm.type','dropdown','hm.state','0');
</script>
</body>
</html>
